<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating OLAP cube reports</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { font-weight:bold; }
ul.whs2 { list-style:disc; }
ol.whs3 { list-style:decimal; }
p.whs4 { color:#ff0000; }
p.whs5 { margin-left:0px; font-weight:bold; }
p.whs6 { margin-left:0px; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs5 {margin-left:1pt; }";
  strNSS += "p.whs6 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nCreating a grid or graph report\nCreating MDX cube reports");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating MDX cube reports</h1>
<p>Many companies have stored data that is specifically structured for 
 query, reporting, and analysis, known as a data warehouse, and they also 
 have data stored in an MDX cube source such as SAP Business Intelligence 
 Warehouse (SAP BW), Microsoft® Analysis Services (Analysis Services), 
 or Hyperion® Essbase®. MicroStrategy's Intelligence Server uses MultiDimensional 
 eXpressions (MDX) to concurrently access both the MDX cube source and 
 the data warehouse effectively. For complete details on how MicroStrategy 
 interacts with these 3rd party data sources, see the <span style="font-style: italic;"><I>MicroStrategy 
 MDX Cube Reporting Guide</I></span>.</p>
<p>The procedure below shows you how to create an MDX cube report, which 
 is a standard MicroStrategy report that draws its data from one of the 
 data sources described above.</p>
<p><span style="font-weight: bold;"><B>Note</B></span>: After you create an MDX 
 cube report using your SAP BW data, you can treat the MDX cube report 
 the same as standard MicroStrategy reports. This means that you can use 
 the MDX cube reports as datasets in Report Services documents.</p>
<p class="whs1">Prerequisites</p>
<ul type="disc" class="whs2">
	
<li class=p><p>You must have a Web Professional license and the Web 
 Define MDX Cube Reports Web Professional privilege to create a report 
 from a cube source such as Analysis Services, Essbase, or SAP BW. If you 
 are an administrator, see the <span style="font-style: italic;"><I>MicroStrategy 
 System Administration Guide</I></span> for details on privileges and how to 
 assign them to users.</p></li>
	
<li class=p><p>At least one MDX cube must be imported into your MicroStrategy 
 project. Importing MDX cubes is often handled by a MicroStrategy architect. 
 For more information on importing MDX cubes into MicroStrategy, see the 
 <span style="font-style: italic;"><I>MicroStrategy MDX Cube Reporting Guide</I></span>.</p></li>
	
<li class=p><p>You must own the MicroStrategy MDX Services product.</p></li>
</ul>
<h2>To create an MDX cube report</h2>
<ol type="1" class="whs3">
	
<li class=p><p>Log in to a project connected to an MDX cube source.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Create Report</B></span> 
 at the top of the page.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Choose MDX Source</B></span> 
 to create a new MDX cube report. The Select MDX Cube dialog box opens. 
 </p></li>
	
<li class=p><p>Select an MDX cube source. Catalogs available for the 
 MDX cube source are displayed. </p></li>
	
<li class=p><p>Select a catalog. MDX cubes available in the catalog 
 are displayed. </p></li>
	
<li class=p><p>Select an MDX cube. </p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>OK</B></span> to 
 open the Report Editor.</p></li>
	
<li class=p><p>Select attributes, metrics, prompts, and other objects 
 required from the All Objects pane and place them on the report.</p></li>
	
<li class=p><p>Format the report, if needed.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Save As</B></span> 
 on the toolbar to save the report and close the Report Editor.</p></li>
</ol>
<p class="whs4">&nbsp;</p>
<p class="whs5"><span style="font-weight: bold;"><B>Related 
 topics</B></span></p>
<ul type="disc" class="whs2">
	
<li class=p><p class="whs6">
<a HREF="Creating_a_new_report.htm">Creating 
 a report</a></p></li>
	
<li class=p><p class="whs6">
<a href="Creating_a_report_using_a_template.htm">Creating 
 a report using a template</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
